package com.entity;
/**
create table score_tb(
 score_id int primary key auto_increment,
 stu_id int references user_tb(user_id),
 lesson_id int references lesson_tb(lesson_id),
 score double(5,1)
);
alter table score_tb add score double(5,1);
 */
public class Score {
	//成绩id
	private Integer score_id;
	//学生id
	private Integer stu_id;
	//课程id
	private Integer lesson_id;
	//分数
	private Double score;
	//教师id
	private Integer teacher_id;
	public Score(Integer score_id, Integer stu_id, Integer lesson_id, Double score, Integer teacher_id) {
		super();
		this.score_id = score_id;
		this.stu_id = stu_id;
		this.lesson_id = lesson_id;
		this.score = score;
		this.teacher_id = teacher_id;
	}
	public Score() {
		super();
	}
	/**
	 * @return the score_id
	 */
	public Integer getScore_id() {
		return score_id;
	}
	/**
	 * @param score_id the score_id to set
	 */
	public void setScore_id(Integer score_id) {
		this.score_id = score_id;
	}
	/**
	 * @return the stu_id
	 */
	public Integer getStu_id() {
		return stu_id;
	}
	/**
	 * @param stu_id the stu_id to set
	 */
	public void setStu_id(Integer stu_id) {
		this.stu_id = stu_id;
	}
	/**
	 * @return the lesson_id
	 */
	public Integer getLesson_id() {
		return lesson_id;
	}
	/**
	 * @param lesson_id the lesson_id to set
	 */
	public void setLesson_id(Integer lesson_id) {
		this.lesson_id = lesson_id;
	}
	/**
	 * @return the score
	 */
	public Double getScore() {
		return score;
	}
	/**
	 * @param score the score to set
	 */
	public void setScore(Double score) {
		this.score = score;
	}
	/**
	 * @return the teacher_id
	 */
	public Integer getTeacher_id() {
		return teacher_id;
	}
	/**
	 * @param teacher_id the teacher_id to set
	 */
	public void setTeacher_id(Integer teacher_id) {
		this.teacher_id = teacher_id;
	}
	/* (non-Javadoc)
	 * @see java.lang.Object#toString()
	 */
	@Override
	public String toString() {
		return "Score [score_id=" + score_id + ", stu_id=" + stu_id + ", lesson_id=" + lesson_id + ", score=" + score
				+ ", teacher_id=" + teacher_id + "]";
	}	
	
	
	
	
	
}
